# Using Microsoft SQL Server as a data warehouse

Information noteAlthough the procedures in this section specifically refer to Microsoft SQL Server, they are equally applicable to Microsoft Azure SQL Managed Instance and Microsoft Azure SQL Database.

It contains the following topics:

* [Prerequisites](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/prerequisites_sql_server.htm)
* [Working with Windows authentication](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/General/windows_authentication_sql.htm)
* [Microsoft SQL Server data types](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/data_types_sql_server.htm)
* [Defining the connection parameters](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/define_connection_parameters_sql_server.htm)